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