UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y75p3u9DoMiek03bCeRD5eNp04bi/kCw4FoTzi+T0S4='
WHERE
key_id = '49fc57a8318f85cd1194bbe5ae8e4665ce2a66e798f11ecf88017640967ac357'
AND (
token = 'Y75p3u9DoMiek03bCeRD5eNp04bi/kCw4FoTzi+T0S4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)