UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hIGowN+LTsYP2LGWtuM3HkFBHCXh4cS3YxuyYhAgNGI='
WHERE
key_id = 'c2efe18f7a796f548bcc2c6ddad3106b24c415a8ddb9f4d170df5db7619dccbd'
AND (
token = 'hIGowN+LTsYP2LGWtuM3HkFBHCXh4cS3YxuyYhAgNGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)