UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v/jWXAyB+7hgTBWQjpRqCUTjUqdWBDnN/LhIq1Rhdag='
WHERE
key_id = 'c42c19c8533853fc930ef1c0b2d407b684af05f1cc9e34d5fc0217e470648afa'
AND (
token = 'v/jWXAyB+7hgTBWQjpRqCUTjUqdWBDnN/LhIq1Rhdag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)