UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ZMIwsr0jMiOtHSB3Gf9ZGv11Wl5gOWoQSBe/43XX98='
WHERE
key_id = '928efe904869dae02d88b9ff83c1b91ce1260d30bced4b795634dffe452e3235'
AND (
token = '9ZMIwsr0jMiOtHSB3Gf9ZGv11Wl5gOWoQSBe/43XX98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)