UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lfp19w6aG4XY5SCiJAo4+ooY6XWn4OHx+eoR6FZvmo8='
WHERE
key_id = 'a7d5ec250541bc05c91c94efbfe6754a74680c0bd80e2ff5daa0dc564358e8b4'
AND (
token = 'Lfp19w6aG4XY5SCiJAo4+ooY6XWn4OHx+eoR6FZvmo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)