UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TJHw+j5ZtEw4uetSwE573WENUH7hDf1ivgQ2nZj7rBE='
WHERE
key_id = '8fa1a2236d9e34356092418cd9a31fc69f2ed009e63ea3f8924de600afaf4b6a'
AND (
token = 'TJHw+j5ZtEw4uetSwE573WENUH7hDf1ivgQ2nZj7rBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)