UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JTGKLdj6F5l96GANYcu9xFzyuIkYjo1JV2CyCP+qatw='
WHERE
key_id = 'dde69edcc8164a0fae567303af3adb3634a26b16a7cf515b9ab9586b9b6d4151'
AND (
token = 'JTGKLdj6F5l96GANYcu9xFzyuIkYjo1JV2CyCP+qatw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)