UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HvX4DOYEjMTyF3t3vF7Y+eKishSeNOKKXn86QzQEKv4='
WHERE
key_id = '1e89315ce5dbea510bb81a98df066d643919c4346e1f8d72727ad58f95d61c67'
AND (
token = 'HvX4DOYEjMTyF3t3vF7Y+eKishSeNOKKXn86QzQEKv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)