UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCpd1faexJakQ73pJYkIqaq2Bq31/rW1JakiOqb7PDA='
WHERE
key_id = '7b11d49501e402079bdcf945645dca321fc94e1bafdc4075875a6466d874ce1d'
AND (
token = 'gCpd1faexJakQ73pJYkIqaq2Bq31/rW1JakiOqb7PDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)