UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hE2WEVLuuGy5qahIJpzXvNWmAjmh6ePJqMDu1mm+N8='
WHERE
key_id = 'e4b2dae13170ba73fff36514579075e47f35d68bcfe4fd62934a684a99a585e4'
AND (
token = '9hE2WEVLuuGy5qahIJpzXvNWmAjmh6ePJqMDu1mm+N8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)