UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y1HOwdGeEvMVNHlR8NLPFS6rZXWqjKca4b9iB1/zmLM='
WHERE
key_id = 'd0e29209ad3fff0ace2342d070a251f538902914a68287f7b2c4372f7f29fe49'
AND (
token = 'Y1HOwdGeEvMVNHlR8NLPFS6rZXWqjKca4b9iB1/zmLM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)