UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LZkfuaiLYnZaUCD5nyIDzCoohoH5bkJ6kopnkiTJYFY='
WHERE
key_id = '0a3eea0da2c632071fd706beb83db4aac986a50412daa9f402235b3f02fce515'
AND (
token = 'LZkfuaiLYnZaUCD5nyIDzCoohoH5bkJ6kopnkiTJYFY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)