UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l7FJZDprVvxU0T8E8nNDIjSq5fKUE3CxDoiJdyhkT80='
WHERE
key_id = '3dbf8f8a72ef8da4a803ad847e648a4700dc0ddc7202fc086d71df78594127b7'
AND (
token = 'l7FJZDprVvxU0T8E8nNDIjSq5fKUE3CxDoiJdyhkT80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)