UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X4cAHTCJ/5Ld19xuRR4Wm585t/lyxVjV1gfMKkv93WE='
WHERE
key_id = 'deb225a7a8904c4155e2fce0f3f7f0f45c21073d3d08efc9e36ef5e6ab6b731c'
AND (
token = 'X4cAHTCJ/5Ld19xuRR4Wm585t/lyxVjV1gfMKkv93WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)