UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CCN+y3DqzpjJRgX0Yxr70dgOIxXPuZ9Cg3iCBg2yq58='
WHERE
key_id = '02319993a507a41953f400649aac2c4fb954649a0be6c9118512c980b249908e'
AND (
token = 'CCN+y3DqzpjJRgX0Yxr70dgOIxXPuZ9Cg3iCBg2yq58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)