UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KAPZEcyZXAOgHD+lfApfdPqUlYkgwXx6IfK1Av9nd8g='
WHERE
key_id = '9e747e589b679d6116e0da16e89a4c4e6c625c0ea25a43df6ed9d21f3527fcd8'
AND (
token = 'KAPZEcyZXAOgHD+lfApfdPqUlYkgwXx6IfK1Av9nd8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)