UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TnpM1ohYsesy5fnpnhewOiGLN49tn959huhq8bGm+I='
WHERE
key_id = '1f70eea44c26ff7a29923898e6cdb0989a0b0428a825a13783fd9b41a72e1451'
AND (
token = '6TnpM1ohYsesy5fnpnhewOiGLN49tn959huhq8bGm+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)