UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ThFIzUIJbXATiFGrBIuP5lvR93xBiJ62OGP4Tr8o+6A='
WHERE
key_id = 'a07fe0df6aefe3d2923b7676ea00db86a0f74319b8c1460282d5aa9c64f13445'
AND (
token = 'ThFIzUIJbXATiFGrBIuP5lvR93xBiJ62OGP4Tr8o+6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)