UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PyjkaKTKYlHS/XPu6VoS+r8Nu4weAK9reK8gw3DrLmo='
WHERE
key_id = 'a97bd5221ad03a620139404671fde7d8c3992c12419a5ca51fc59ea259bce6cd'
AND (
token = 'PyjkaKTKYlHS/XPu6VoS+r8Nu4weAK9reK8gw3DrLmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)