UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZ0TC7r2WlJfksv3+OpZEJUqvKWzcbcn4L3YE0vIj2M='
WHERE
key_id = 'e2581e92b0632a11dd23bba5026eb4300e9afa181a1ca73e124d17ea4165edf3'
AND (
token = 'ZZ0TC7r2WlJfksv3+OpZEJUqvKWzcbcn4L3YE0vIj2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)