UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k/qaDVQTcr2TuvV66Voxaos5I20rGnLTcaHnO7JCNBU='
WHERE
key_id = 'd7d06aab7642db21bd54e5c060f7f3362166c49864924ac4fe104997ccf8a822'
AND (
token = 'k/qaDVQTcr2TuvV66Voxaos5I20rGnLTcaHnO7JCNBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)