UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4YdtESPKSfPwzYpPTsgVYux9XXuuP85r0lncctyJzaA='
WHERE
key_id = 'e6dcfd05ef3fafcf90944be29cc8ad10f7e8e09370e04f132e704b9bcf55df03'
AND (
token = '4YdtESPKSfPwzYpPTsgVYux9XXuuP85r0lncctyJzaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)