UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c/VPk7e2sn/b7bSgRvhX90fIzzHHT1wQtiGNnKigE1s='
WHERE
key_id = 'f78c35eade61ab3daf29b082c27a6275c6313430bd2c4811ec20623f6f683364'
AND (
token = 'c/VPk7e2sn/b7bSgRvhX90fIzzHHT1wQtiGNnKigE1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)