UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2OTxaL5iNHbcjKEvV1RaRUxDo6TyVBteuT/nl5YfmG4='
WHERE
key_id = 'd007f938a184189c2f7117769711ceea5cfd8b89b3500b82d40d2922f999f765'
AND (
token = '2OTxaL5iNHbcjKEvV1RaRUxDo6TyVBteuT/nl5YfmG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)