UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G6PX/oCogtbEp2a2cgd2Yh/37IgEMYeGNdLx9kPgVrk='
WHERE
key_id = 'db4a7d553812edc00b70e03ef6b92a0ceeb10cb049973d509a9ec06b1c463065'
AND (
token = 'G6PX/oCogtbEp2a2cgd2Yh/37IgEMYeGNdLx9kPgVrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)