UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tz8cU9eLfW/adVM/A6TlHxZXNSMYicvSKjhULq0Mi5k='
WHERE
key_id = '1e38a242d1ae1cceaf11a4a60c9e92d1e30269c9d8b6aaa6f845095e7234d1a7'
AND (
token = 'Tz8cU9eLfW/adVM/A6TlHxZXNSMYicvSKjhULq0Mi5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)