UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z//+pBO+klqS6xoT86BQ5cDSFwYMcTILYk1pFuB0gU8='
WHERE
key_id = 'eda192f27bf7548173dc43d1b3ac7819151d42baa87453ab33976a823188bbbb'
AND (
token = 'z//+pBO+klqS6xoT86BQ5cDSFwYMcTILYk1pFuB0gU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)