UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'twNkQKkkRAEnRkI/+ygDLF8VUP6onTjcs0FHuAMuwfc='
WHERE
key_id = 'e4c2171ba9fb02c99e5b1f56bdf6489395302f5df25334dbb677f8569531f8fa'
AND (
token = 'twNkQKkkRAEnRkI/+ygDLF8VUP6onTjcs0FHuAMuwfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)