UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '046X7vIvBDFH7453RByJIMeHE6B3jAMWNSmq4X5PSjk='
WHERE
key_id = 'cc12b7a1283fbae0badeafb97f17f319001d5362e98a6946112dae9172b46900'
AND (
token = '046X7vIvBDFH7453RByJIMeHE6B3jAMWNSmq4X5PSjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)