UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4CL2+Qkcpv2fxD/syCqb0qbfIG6hvO3FPXgTameceAQ='
WHERE
key_id = '1870bd380b785f21802b777ce603501a7ff381003bb73c611cee6266ea147fc6'
AND (
token = '4CL2+Qkcpv2fxD/syCqb0qbfIG6hvO3FPXgTameceAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)