UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hzhgUhwHwI99d8AUdh13G2TFm6SWPS82IpAZ9O4ScGc='
WHERE
key_id = 'ca2c28f14c7618b423761cfaae531fe677eab6211ccf15783563833f415c8977'
AND (
token = 'hzhgUhwHwI99d8AUdh13G2TFm6SWPS82IpAZ9O4ScGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)