UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pb8xmXgzBHLx5a9h/HHnn2Av2TwDx3q7e8PXS2eR/SI='
WHERE
key_id = '28bca6da9b16b7f06e9459505fdac456147151e58b47084e40a06c4b1a976b96'
AND (
token = 'pb8xmXgzBHLx5a9h/HHnn2Av2TwDx3q7e8PXS2eR/SI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)