UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HgIU5bgQkn1yCDwelA31Oh5X2+calIKBla70KGJczmE='
WHERE
key_id = 'dc8c90e203cbb592909c660f8afc811d889a2ddb777150e89c7c331549dde9e8'
AND (
token = 'HgIU5bgQkn1yCDwelA31Oh5X2+calIKBla70KGJczmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)