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