UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v/PCjad97aQvtbSFdEDfZ9NP9IdAZ8qKXpPnEszvAwU='
WHERE
key_id = 'c94b4f189db3374de6b524ed73de133292ac1689665d69dcd64d4b908721b217'
AND (
token = 'v/PCjad97aQvtbSFdEDfZ9NP9IdAZ8qKXpPnEszvAwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)