UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JbcA2Xci/H1f3YO242z6PDPp2p4WpULvJvDV01wPdP0='
WHERE
key_id = 'a19e4216afd7aa23f4a434d96eb4d17d90f4de40308590b03cf5016eab4b9981'
AND (
token = 'JbcA2Xci/H1f3YO242z6PDPp2p4WpULvJvDV01wPdP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)