UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RM0OobII6/1ianhMV9MXVr92wsSeNe12k8TFpE1nMdg='
WHERE
key_id = 'a5e22e3844583db3994b813065e29d11c9041ec0a18fa1f3e3a9da1af921dc27'
AND (
token = 'RM0OobII6/1ianhMV9MXVr92wsSeNe12k8TFpE1nMdg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)