UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nWzKSbmcpZNkwodWf1muN82v3nfK3gNy3nt7sMosrD8='
WHERE
key_id = 'bda0af6f9f62dc62b239c3a388330a8905b95000c64f2f1c5b2ce780b0fa9580'
AND (
token = 'nWzKSbmcpZNkwodWf1muN82v3nfK3gNy3nt7sMosrD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)