UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gLgmHTqHJ0cZwKBaY78OHHPQeCcALgnvfNQEo6Ujiv0='
WHERE
key_id = 'c82f725dbe1e765f4b3a8f0c6601cadc07344179ba955246054613f740c63f8c'
AND (
token = 'gLgmHTqHJ0cZwKBaY78OHHPQeCcALgnvfNQEo6Ujiv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)