UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZcrnIlQIPytbpCcrFUnb4Gc3/hUW+kFBlVD4lZZZlnM='
WHERE
key_id = '8bac831e4946e12c5d086e0b399003741730a36e8b706093fc94ab8b4d1269df'
AND (
token = 'ZcrnIlQIPytbpCcrFUnb4Gc3/hUW+kFBlVD4lZZZlnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)