UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4n4DR2V5xrhJs95EHYM0vyQmpZFVb/ui/45TrE3gWpM='
WHERE
key_id = '50f30195c5ddee711723502a3833859e9e0a59746d089defbbb00971f54fa56a'
AND (
token = '4n4DR2V5xrhJs95EHYM0vyQmpZFVb/ui/45TrE3gWpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)