UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C3cAsFxq1lBoz3Gj6/tWV5lMvGKN+/iVuVlOUApf6YM='
WHERE
key_id = 'b43031c9e099fc60a14f565a524589bc5dccab98137816503fb01ce52af5aec6'
AND (
token = 'C3cAsFxq1lBoz3Gj6/tWV5lMvGKN+/iVuVlOUApf6YM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)